Editing Database General

Options for SQL Server

Database Name
Define the name of the database.

Owner
Choose the owner of the database.

Collation
Choose the default collation for the database. Collation name can be either a Windows collation name or a SQL collation name. If not specified, the database is assigned the default collation of the instance of SQL Server. A collation name cannot be specified on a database snapshot.

Recovery Model
Control database recovery options and disk I/O error checking.

FULL
Provide full recovery after media failure by using transaction log backups. If a data file is damaged, media recovery can restore all committed transactions.

BULK_LOGGED
Provide recovery after media failure by combining the best performance and least amount of log-space use for certain large-scale or bulk operations.

SIMPLE
A simple backup strategy that uses minimal log space is provided. Log space can be automatically reused when it is no longer required for server failure recovery.

Compatibility Level
The version of SQL Server with which the database is to be made compatible.

Options for SQL Azure

Database Name
Define the name of the database.

Edition
Choose the edition of the database: Web or Business.

Max Size
Choose the maximum size of the database.